package sicnu.cs.aps.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import sicnu.cs.aps.domain.dto.CollegeInfoDto;
import sicnu.cs.aps.domain.entity.CollegeInfo;
import sicnu.cs.aps.domain.entity.Major;

import java.util.List;

/**
 * description 学院信息mapper
 *
 * @author chenhetao
 * @version 1.0
 * @className CollegeInfoMapper
 * @packageName sicnu.cs.aps.mapper
 * @date 2022/5/26 18:51
 */
@Mapper
public interface CollegeInfoMapper extends BaseMapper<CollegeInfo> {

    List<CollegeInfo> selectIDAndName();

    CollegeInfo selectCollegeInfoBySubId(@Param("userId") Long userId);

    List<CollegeInfoDto> selectCollegeInfoByName(@Param("name") String name);

    List<CollegeInfoDto> selectAllCollegeIdAndName();

    List<CollegeInfoDto> selectCollegeInfoAndMajor();

}
